SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwbAsignaturasGenericas
AS
SELECT     dbo.tb_AsignaturasGenericas.idAsignaturaGenerica AS ID, dbo.vwrAsignaturasGenericas.Descripcion, 
                      dbo.vwrTiposEspaciosCurriculares.Descripcion AS TipoEspCurricular
FROM         dbo.tb_AsignaturasGenericas INNER JOIN
                      dbo.vwrAsignaturasGenericas ON dbo.tb_AsignaturasGenericas.idAsignaturaGenerica = dbo.vwrAsignaturasGenericas.ID INNER JOIN
                      dbo.vwrTiposEspaciosCurriculares ON dbo.tb_AsignaturasGenericas.Tipo = dbo.vwrTiposEspaciosCurriculares.ID
GO
GRANT SELECT ON  [dbo].[vwbAsignaturasGenericas] TO [Juntas]
GRANT SELECT ON  [dbo].[vwbAsignaturasGenericas] TO [RegistroTitulos]
GRANT SELECT ON  [dbo].[vwbAsignaturasGenericas] TO [SoloVer]
GO
